package com.gcloud.persistance;

public class Querys {

	public static final String createTableIndex = "CREATE TABLE INDEX_FILE_SERVICE IF NOT EXISTS ("
			+ "KEY  TEXT(100) PRIMARY KEY NOT NULL,"
			+ "NAME TEXT(100),"
			+ "DESCRIPTION TEXT(100),"
			+ "MIMETYPE  TEXT(50),"
			+ "ACCOUNT  TEXT(100),"
			+ "URI TEXT(100),"
			+ "SERVICE INT,"
			+ "SIZE INT(20),"
			+ "IS_DIRECTORY INT(1),"
			+ "IS_FAVORITE INT(1),"
			+ "CONSTRAINT fkey0 FOREIGN KEY (SERVICE) REFERENCES ACCOUNT (ID)"
			+ ");";

	public static final String createAccountTable = "CREATE TABLE ACCOUNT IF NOT EXISTS ("
			+ "ID INT PRIMARY KEY AUTOINCREMENT NOT NULL,"
			+ "SERVICE TEXT(50),"
			+ "ACCOUNT TEXT(50),"
			+ "KEY  TEXT(100)," + "KEY_SECRET  TEXT(100)" + ");";

}
